Customize connection options according to your needs. The detailed description is given below:
Settings Save Path
When a new connection being established, Navicat will create a subfolder under the Settings Save Path. Most files are stored within this subfolder:
Navicat Objects
|
Server Type
|
File Extensions
|
Query | All | .sql |
Query Builder | All | .qbs - stores the layout of tables in Query Builder. |
Import Wizard Profile | MySQL | .npi |
Oracle | .nopi | |
PostgreSQL | .nppi | |
SQLite | .nlpi | |
SQL Server | .nmpi | |
Export Wizard Profile | MySQL | .npe |
Oracle | .nope | |
PostgreSQL | .nppe | |
SQLite | .nlpe | |
SQL Server | .nmpe | |
Export Query Result Profile | MySQL | .npeq |
Oracle | .nopeq | |
PostgreSQL | .nppeq | |
SQLite | .nlpeq | |
SQL Server | .nmpeq | |
Export View Result Profile | MySQL | .npev |
Oracle | .nopev | |
PostgreSQL | .nppev | |
SQLite | .nlpev | |
SQL Server | .nmpev | |
Export Materialized View Profile | Oracle | .nopem |
Backup | MySQL, PostgreSQL and SQLite | .pmb |
Other files are located in the default folder, e.g. ~/Library/Application Support/Navicat Premium. You are allowed to change location under Preferences.
Other Files
|
File Extensions
|
Virtual Grouping | vgroup.xml - stores how the objects are categorized. |
Hint: All your connection settings and other profiles are stored in Property List file.
See also:
Log Files
MySQL and PostgreSQL
Keepalive interval (sec)
This option allows you to keep the connection with the server alive by pinging it. You can set the period between pings in the edit field.
Auto connect
With this option on, Navicat automatically opens connection with the registered database at application startup.
Use socket file
With this option on, Navicat uses socket file for localhost connection.
Oracle and SQL Server
Keepalive interval (sec)
This option allows you to keep the connection with the server alive by pinging it. You can set the period between pings in the edit field.
Auto connect
With this option on, Navicat automatically opens connection with the registered database at application startup.
SQLite
Auto connect
With this option on, Navicat automatically opens connection with the registered database at application startup.
Encrypted
Enable this option and provide Password when connecting to an encrypted SQLite database.Attached Databases
To attach or detach databases in the connection.
See also:
Database Management for MySQL
Schema Management for Oracle
Database Management for PostgreSQL
Database Management for SQLite
Database Management for SQL Server